<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
        <title>Untitled Document</title>
        <style type="text/css">
            #apDiv1 {
                position: absolute;
                width: 958px;
                height: 384px;
                z-index: 1;
                left: 237px;
                top: 130px;
                background-color: #CFCFCF;
            }
            #apDiv2 {
                position: absolute;
                width: 1184px;
                height: 115px;
                z-index: 2;
                left: 8px;
                top: 6px;
                background-color: #FF3C3C;
            }
            #apDiv3 {
                position: absolute;
                width: 209px;
                height: 212px;
                z-index: 2;
                left: 14px;
                top: 131px;
                background-color: #CFCFCF;
            }
            body,td,th {
                font-family: "Trebuchet MS", Arial, Helvetica, sans-serif;
            }
            a:link {
                color: #2821B8;
                text-decoration: none;
            }
            #apDiv1 h1 {
                color: #FF3C3C;
            }
            a:visited {
                text-decoration: none;
            }
            a:hover {
                text-decoration: none;
            }
            a:active {
                text-decoration: none;
            }
            body {
                background-color: #838383;
            }
        </style>
    </head>
    <body>
        <h1>&nbsp;</h1>
        <div id="apDiv1">
            <h1>Form Kirim Barang</h1>
            <table width="739" border="1">
                <tr align="center">
                    <td width="22"><strong>No</strong></td>
                    <td width="53"><strong>Kd_Psn</strong></td>
                    <td width="54"><strong>Kd_Brg</strong></td>
                    <td width="54"><strong>Id_Plgn</strong></td>
                    <td width="54"><strong>Tgl_Psn</strong></td>
                    <td width="54"><strong>Nm_Toko</strong></td>
                    <td width="138"><strong>Jml_Aqua_Gel</strong></td>
                    <td width="103"><strong>Jml_Aqua_BK</strong></td>
                    <td width="101"><strong>Jml_Aqua_BS</strong></td>
                    <td width="103"><strong>Jml_Aqua_BB</strong></td>
                    <td width="113"><strong>Jml_Aqua_Gal</strong></td>
                    <td width="113"><strong>Details</strong></td>
                </tr>
                <?php
                include("Koneksi.php");
                $q = "select * from pesanan where catatan is null";
                $rs = oci_parse($conn, $q);
                oci_execute($rs);
                $i = 1;
                ?> 
                <?php
                while ($dt = oci_fetch_assoc($rs)) {
                    ?>
                    <tr>
                        <td><?php echo $i; ?></td>
                        <td><?php echo $dt['KODE_PESANAN'] ?></td>
                        <td><?php echo $dt['KODE_BARANG'] ?></td>
                        <td><?php echo $dt['ID_PELANGGAN'] ?></td>
                        <td><?php echo $dt['TANGGAL_PESAN'] ?></td>
                        <td><?php echo $dt['NAMA_TOKO'] ?></td>
                        <td><?php echo $dt['JML_AQUA_GELAS'] ?></td>
                        <td><?php echo $dt['JML_AQUA_BOTOL_KECIL'] ?></td>
                        <td><?php echo $dt['JML_AQUA_BOTOL_SEDANG'] ?></td>
                        <td><?php echo $dt['JML_AQUA_BOTOL_BESAR'] ?></td>
                        <td><?php echo $dt['JML_AQUA_GALON'] ?></td>
                        <td align="center"><a href="DetailsFormTerimaPesanan.php?kd_pesanan=<?php echo $dt['KODE_PESANAN']; ?>">Details</a></td>
                    </tr>
                    <?php
                    $i++;
                };
                ?>
            </table>
            <p>&nbsp;</p>
            <p>&nbsp;</p>
        </div>
        <p>&nbsp;</p>
        <div id="apDiv2">
            <h1>Distributor Aqua</h1>
        </div>
        <div id="apDiv3">
            <table width="208" border="0">
                <tr>
                    <td align="center" bgcolor="#FF3C3C"><a href="FormTerimaBarang.php">Form Terima Barang</a></td>
                </tr>
                <tr>
                    <td align="center" bgcolor="#FF3C3C"><a href="FormKirimBarang.php">Form Kirim Barang</a></td>
                </tr>
                <tr>
                    <td align="center" bgcolor="#FF3C3C"><a href="FormTerimaPesanan.php">Form Terima Pesanan</a></td>
                </tr>
                <tr>
                    <td align="center" bgcolor="#FF3C3C"><a href="Lainnya.php">Lainnya</a></td>
                </tr>
                <tr>
                    <td align="center" bgcolor="#FF3C3C"><a href="FormLogin.php">Logout</a></td>
                </tr>
            </table>
        </div>
    </body>
</html>
